select * from products where pro_name like '%Train%dresses%' or pro_des like '%Train%dresses%'union all select * from products where (pro_name like '%Train%' or pro_des like '%Train%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Train%dresses%' or pro_des not like '%Train%dresses%')
Sweetheart Empire Lavender Ruched Chiffon Knee-length Dama Dress
One Shoulder Champagne Dama Dress with Handmade Flower and Belt
Lavender Beaded One Shoulder Chiffon Knee-length Dama Dress
One Shoulder Pleated Pink Chiffon Empire Brush Train Dama Dress
Baby Pink Empire One Shoulder Brush Train Formal Dresses For Dama
Royal Blue A-line One Shoulder Brush Train Cocktail Dresses For Dama
Light Yellow Sweetheart Brush Train 15 Dresses For Damas Beaded
Royal Blue Straps Brush Train Chiffon Ruched Formal Dresses for Dama
Baby Pink Sweetheart Quinceanera Gown with Appliques and Overskirt
Popular Purple Sweet Sixteen Dresses with Embroidery and Pick-ups
Custom Made Strapless Embroidery Quinceanera Dress with Overskirt
Exquisite Halter Embroidered Olive Green Dress for Quinceaneras
Aqua Sweetheart Brush Train Quince Dresses with Hand Made Flowers
Wonderful Spring Green Paillette Sweet 16 Dress with Appliques
Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket
Court Train Quinceanera Dresses in Apple Green with Taffeta
Chapel Train Burgundy Pick-ups Appliques Sweet 16 Dresses
A-line Sweetheart Embroidery and Beading Baby Blue Sweet 15 Dresses
Quinceanera Dress Strapless with Embroidery and Beading in Baby Blue
Baby Pink Sweetheart Quinceanera Dress with Beaded Sweetheart
A-line Strapless Appliques Paillette Sweet Sixteen Dresses in Blue
Aqua Blue Sweetheart Appliques Lace up Quinceanera Dresses
Ruching Sweetheart Baby Pink Quinceanera Dress with Layered Ruffles
Dark Purple Brush Train Beading and Ruching 2013 Sweet 16 Dresses
Dark Purple Brush Train Beading and Ruffles Sweet Sixteen Dresses
Brush Train and Boning Details Hot Pink Princess Beading Dresses 15
Hot Pink Quinceanera Dress Hand Made Flowers With Embroidery
Appliques Layered Ruffles Colorful Dresses 15 Wear For Graduation
Long Sleeves and Appliques Decorated Quinceanera Dress in Fushsia
Halter Top and Pick-ups Quinceanera Dress with Beading Embroidery